﻿using System.Collections.Generic;
using System.Data;
using MaLu.Data;
using System;

namespace MaLu.BusiLogic
{
    public class BLMove
    {

        public static DataTable GetMoveDetailList(IDbProvider provider, int Year)
        {
            List<IDataParameter> paraList = new List<IDataParameter>();

            paraList.Add(SqlHelper.Instance.CreateParameter("@Year", DataType.Int32, 8, Year));

            DataSet ds = SqlHelper.Instance.ExecuteProcedure(provider, "Proc_GetMoveDetailList", paraList.ToArray());

            return ds.Tables[0];


        }
       public static void DeleteMove(IDbProvider provider, int mid)
       {
           SqlHelper.Instance.ExecuteNonQuery(provider, "delete from moving where id="+mid);
       }
    } 
}
